Release 10.1A: OpenEdge Data Management:
Database Administration

PROSTRCT utility

Creates and maintains an OpenEdge database. For example, you can use PROSTRCT and its qualifiers to perform the following tasks:

Create a new database from an existing structure description (.st) file.
Display storage usage statistics including information about storage areas in a database.
Add areas and extents to a database.
Remove areas and extents from a database.

Syntax

prostrct qualifier db-name [ structure-description-file ]

Parameters

qualifier

Specifies the qualifier that you want to use. You can supply the following qualifiers:

ADD
ADDONLINE
BUILDDB
CLUSTER CLEAR
CREATE
LIST
REMOVE
REORDER AI
REPAIR
STATISTICS
UNLOCK

Details of the qualifiers are found in the PROSTRCT subsections listed in the following pages.

db-name

Specifies the database you are using.

structure-description-file

Specifies the new .st file. Do not use dbname.st.

Notes

You must define your database structure in a .st file before you create a database. PROSTRCT CREATE creates a database control (DB) area from the information in the .st file.
See Chapter 1, "Creating and Deleting Databases," for a complete description of structure description files and storage areas.
PROSTRCT supports the use of internationalization startup parameters such as -cpinternal codepage and -cpstream codepage. See Chapter 18, "Database Startup Parameters," for a description of each database-related internationalization startup parameter.